package com.baturu.vin.benz.dal.dao;

import com.baturu.vin.benz.dto.BenzSpring;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author jiangxinlei
 * @Time 2017/4/25.
 */
public interface BenzSpringDAO {

    /**
     * 查询弹簧信息
     *
     * @param whc
     * @param chassBm
     * @param chassIdent
     * @return
     */
    @Select({"select FRONT_SPRING_STRUT as FrontSpringStrut, FRONT_SPRING as FrontSpring, REAR_SPRING as RearSpring, REAR_SPRING_SUPPL as RearSpringSuppl from benz_spring_parts_v ",
            "where WHC = #{whc} ",
            "AND CHASSBM = #{chassbm} ",
            "AND CHASS_IDENT = #{chassIdent}"})
    BenzSpring getBenzSpring(@Param("whc") String whc, @Param("chassbm") String chassBm, @Param("chassIdent") String chassIdent);

}
